{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Title Page","Contents","T1 Summary","T2 Input Costs","T3 Alf Est Calendar <15\" ppt","T4 Alfalfa Est <15\" ppt","T5 Alf Est Calendar >15\" ppt","T6 Alfalfa Est >15\" ppt","T7 Calendar for 1 cutting","T8 Alf Prod, 1 cutting","T9 Calendar for 2 cuttings","T10 Alf Prod, 2 cuttings","T11-15 Machinery Costs","T16 Machinery Complement"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":2,"defined_names":88,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Title Page","index":0,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[[26,8,28,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Organic Alfalfa Management Guide"]
[]
[null,null,null,"Spreadsheet for Dryland Organic Alfalfa Production"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Photo by Rob Mikkelson"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Kathleen Painter, PhD"]
[null,null,null,null,null,"Analyst, Center for Sustaining Ag and Natural Resources"]
[null,null,null,null,null,"Affiliate, School of Economic Sciences"]
[null,null,null,null,null,"207A Hulbert Hall"]
[null,null,null,null,null,"Pullman WA 99164-6210"]
[null,null,null,null,null,"(509) 335-5807"]
[null,null,null,null,null,"kpainter@wsu.edu"]

{"sheet":"Contents","index":1,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[5,1,5,4]]}
[]
[]
[null,"Table of Contents"]
[]
[null,"Table 1. Summary of Returns for Dryland Organic Alfalfa Production ($/acre/yr)"]
[null,"Table 2. Input Costs"]
[null,"Table 3. Schedule of Operations for Establishing Dryland Organic Alfalfa, <15\" Annual Rainfall"]
[null,"Table 4. Production Costs for Establishing Dryland Organic Alfalfa, <15\" Annual Rainfall"]
[null,"Table 5. Schedule of Operations for Establishing Dryland Organic Alfalfa, <15\" Annual Rainfall"]
[null,"Table 6. Production Costs for Establishing Dryland Organic Alfalfa, >15\" Annual Rainfall"]
[null,"Table 7. Schedule of Operations for Producing Organic Dryland Alfalfa, 1 Cutting"]
[null,"Table 8. Production Costs for Dryland Organic Alfalfa Production, 1 cutting"]
[null,"Table 9. Schedule of Operations for Producing Dryland Organic Alfalfa, >15\" Annual Rainfall (2 cuttings)"]
[null,"Table 10. Production Costs for Dryland Organic Alfalfa Production, > 15\" Annual Rainfall (2 cuttings)"]
[null,"Table 11. Per Acre Machinery Costs by Type"]
[null,"Table 12. Per Acre Machinery Costs for Establishing Dryland Organic Alfalfa, <15\" Annual Rainfall (1 cutting)"]
[null,"Table 13. Per Acre Machinery Costs for Establishing Dryland Organic Alfalfa, >15\" Annual Rainfall (1 cutting)"]
[null,"Table 14. Per Acre Machinery Costs for Producing Dryland Organic Alfalfa, <15\" Annual Rainfall (1 cutting)"]
[null,"Table 15. Per Acre Machinery Costs for Producing Dryland Organic Alfalfa, >15\" Annual Rainfall (2 cuttings)"]
[null,"Table 16. Machinery Complement for Dryland Organic Alfalfa Production"]

{"sheet":"T1 Summary","index":2,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[44,1,44,11],[0,3,0,5],[40,1,40,11],[41,1,41,11],[39,1,39,11],[42,1,42,11],[43,1,43,11]]}
[null,"Input Costs",null,"Machinery Complement"]
[null,"Legend: Follow directions below to preserve equations in this spreadsheet."]
[null,"Yellow cells: Data are from Summary page (yellow tab)."]
[null,"Orange cells: Revise data here to reflect your situation."]
[null,"Green cells: Data are from Input Costs page (green tab)."]
[null,"Blue cells: Data are from the Machinery page (blue tab)."]
[null,"Please change yield, price, and length of stand assumptions as necessary to reflect your situation."]
[null,"Table 1. Summary of Returns for Dryland Organic Alfalfa Production ($/acre/yr)"]
[]
[null,null,null,"Total ",null,null,null,null,null,null,"Total"]
[null,null,null,"Cost (TC) of",null,"Yield ",null,"Price","Revenue","Returns","Operating","Returns"]
[null,null,null,"Operation","Unit","per acre",null,"per unit","per acre","over TC","Costs (OC)","over OC"]
[null,null,null,"($/acre)",null,"(units/ac)",null,"($/unit)","($/acre)","($/acre)","($/acre)","($/acre)"]
[null,"Under 15\" rainfall:"]
[null,"Alfalfa Establishment",null,{"$f":"+'T4 Alfalfa Est <15\" ppt'!$J$72","v":230.94292857142855},"ton",1.5,null,200,{"$f":"+H15*F15","v":300},{"$f":"+F15*H15-D15","v":69.057071428571447},{"$f":"+'T4 Alfalfa Est <15\" ppt'!$J$57","v":130.81642857142856},{"$f":"+I15-K15","v":169.18357142857144}]
[null,"Production, 1 cutting",null,{"$f":"+'T8 Alf Prod, 1 cutting'!$J$68","v":87.898499999999999},"ton",2.5,null,200,{"$f":"+H16*F16","v":500},{"$f":"+F16*H16-D16","v":412.10149999999999},{"$f":"+'T8 Alf Prod, 1 cutting'!$J$51","v":0},{"$f":"+I16-K16","v":500}]
[null,"Length of stand (yrs)",10]
[]
[null,"15\" or more rainfall:"]
[null,"Alfalfa Establishment",null,{"$f":"+'T6 Alfalfa Est >15\" ppt'!J72","v":253.19592857142854},"ton",2.5,null,200,{"$f":"+H20*F20","v":500},{"$f":"+F20*H20-D20","v":246.80407142857146},{"$f":"+'T6 Alfalfa Est >15\" ppt'!$J$57","v":133.94842857142854},{"$f":"+I20-K20","v":366.05157142857149}]
[null,"Production, 2 cuttings",null,{"$f":"+'T10 Alf Prod, 2 cuttings'!$J$67","v":400.91521071428565},"ton",3.5,null,200,{"$f":"+H21*F21","v":700},{"$f":"+F21*H21-D21","v":299.08478928571435},{"$f":"+'T10 Alf Prod, 2 cuttings'!$J$51","v":286.61671071428566},{"$f":"+I21-K21","v":413.38328928571434}]
[null,"Length of stand (yrs)",5]
[]
[null,"NOTES: Production costs include an amortized payment each year if losses are incurred during establishment."]
[null,"Areas with less than 15\" annual rainfall are assumed to need re-seeding 1 year in 5 and to have 1 cutting per year. "]
[null,"Areas with 15\" or more annual rainfall are assumed to require re-seeding 1 year in 10 and to have 2 cuttings per year. "]
[]
[null,"ASSUMPTIONS:"]
[null,"1. Land values are assumed to be $1500 per acre for land with < 15\" precipitation per year and $2000 per acre for land 15\" or more precipitation per year."]
[null,"   Annual land rent is assumed to be 4% of the market value of the land per year, representing an appropriate return on investment."]
[null,"   Land value can be changed in the Input Costs tab."]
[null,"2. The interest rate on machinery and operating costs is assumed to be 7%. "]
[null,"3. All labor costs are estimated at $20.00/hour. This value can be changed in the Input Costs tab."]
[null,"4. Machinery replacement schedule as well as other machinery assumptions are listed in the Machinery Complement and Machinery Costs tabs."]
[null,"5. For the purpose of machinery use calculations, farm size is assumed to be 1500 acres."]
[null,"6. Click on the links above to view input cost and machinery complement assumptions."]

{"sheet":"T2 Input Costs","index":3,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[39,1,39,4],[37,1,37,4],[38,1,38,4],[7,1,7,4]]}
[null,"Back to Summary",null,"Back to Contents"]
[null,"Legend: Follow directions below to preserve equations in this spreadsheet."]
[null,"Yellow cells: Data are from Summary page (yellow tab)."]
[null,"Orange cells: Revise data here to reflect your situation."]
[null,"Green cells: Data are from Input Costs page (green tab)."]
[null,"Blue cells: Data are from the Machinery page (blue tab)."]
[]
[null,"Table 2. Input Costs"]
[]
[null,"Fuel:","Unit","Price/unit"]
[null,"Diesel ","gal",2.5]
[null,"Gas","gal",1.75]
[]
[null,"Seed:"]
[null,"Alfalfa Seed ","lb",3]
[]
[null,"Fertilizer:"]
[null,"Manure (hauled  & spread)","ton",25]
[]
[null,"Labor:"]
[null,"Hourly machine labor*","hour",20]
[]
[null,"Other:"]
[null,"Soil test","acre",0.3]
[null,"Twine","ton",2]
[null,"Tarping","ton",4]
[null,"Stacking","ton",9]
[null,"Gopher control","acre",2]
[null,"Crop insurance","ton",2]
[null,"Land tax","acre",5.5]
[null,"Land value, <15\" precipitation","acre",1500]
[null,"Land value, >=15\" precipitation","acre",2000]
[]
[null,"*Includes all applicable state and federal taxes."]

{"sheet":"T3 Alf Est Calendar <15\" ppt","index":4,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[32,1,32,4],[33,1,33,4],[1,1,1,4]]}
[null,"Back to Summary",null,"Alfalfa Establishment, <15\" ppt",null,null,"Machine Costs",null,"Machine Complement"]
[null,"Table 3. Schedule of Operations for Establishing Dryland Organic Alfalfa, <15\" Annual Rainfall"]
[null,"Month","Operation","Tooling"]
[]
[null,"November","Chisel","300HP-WT, 23' Chisel Plow"]
[]
[null,"April","Soil test"]
[]
[null,"April","Apply Manure","Custom spreading"]
[]
[null,"April","Disc","300HP-WT, 35' Tandem Disc"]
[]
[null,"April","Harrow","300HP-WT, 53' Rotary Harrow"]
[]
[null,"April","Pack","300HP-WT, 40' Packer"]
[]
[null,"April","Drill","300HP-WT, 30' Disc Drill"]
[]
[null,"June","Mow Weeds","300HP-WT, 20' Flail Shredder"]
[]
[null,"July","Swath Forage","18' Swather"]
[]
[null,"July","Bale Forage","300HP-WT, 1500-lb Round Baler"]
[]
[null,"July","Pick up & stack bales","300HP-WT, Bale Spear"]
[]
[null,"August","Mow Weeds","300HP-WT, 20' Flail Shredder"]
[]
[null,"September","Mow Weeds","300HP-WT, 20' Flail Shredder"]

{"sheet":"T4 Alfalfa Est <15\" ppt","index":5,"n_rows":100,"n_cols":10,"rows_kept":100,"cut":false,"hidden":false,"merged":[[63,1,63,3],[64,1,64,3],[7,1,7,10],[12,12,12,16],[13,12,13,17],[62,1,62,3],[104,1,104,9],[108,1,108,9],[107,1,107,9],[106,1,106,9],[105,1,105,9]]}
[null,"Back to Summary",null,"Input Costs",null,"Calendar",null,"Machine Costs",null,"Machine Complement"]
[null,"Legend: Follow directions below to preserve equations in this spreadsheet."]
[null,"Yellow cells: Data are from Summary page (yellow tab)."]
[null,"Orange cells: Revise data here to reflect your situation."]
[null,"Green cells: Data are from Input Costs page (green tab)."]
[null,"Blue cells: Data are from the Machinery page (blue tab)."]
[null,"Please change yield, price, and length of stand assumptions as necessary to reflect your situation."]
[null,"Table 4. Production Costs for Establishing Dryland Organic Alfalfa, <15\" Annual Rainfall"]
[null,null,null,"Quantity",null,null,null,"Price or",null,"Value or"]
[null,"Item",null,"Per Acre",null,"Unit",null,"Cost/Unit",null,"Cost/Acre"]
[]
[null,"Gross Returns"]
[null,"Alfalfa",null,{"$f":"LowRainfallEstYd","v":1.5},null,"ton",null,{"$f":"'T1 Summary'!H15","v":200},null,{"$f":"D13*H13","v":300}]
[]
[null,"Operating Inputs"]
[]
[null,"Seed:",null,null,null,null,null,null,null,{"$f":"SUM(J18:J21)","v":43.2}]
[null,"Alfalfa Seed",null,12,null,"lb",null,{"$f":"+AlfalfaSeed","v":3},null,{"$f":"D18*H18","v":36}]
[null,"Alfalfa Seed for re-seeding",null,{"$f":"+D18*0.2","v":2.4000000000000004},null,"lb",null,{"$f":"+AlfalfaSeed","v":3},null,{"$f":"D19*H19","v":7.2000000000000011}]
[null,"   (assume 20% of the time)"]
[]
[]
[null,"Fertilizer:",null,null,null,null,null,null,null,{"$f":"SUM(J24:J26)","v":0}]
[null,"Manure or organic fertilizer",null,null,null,"ton",null,{"$f":"+Manure","v":25},null,{"$f":"D24*H24","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D25*H25","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D26*H26","v":0}]
[]
[null,"Pesticides:",null,null,null,null,null,null,null,{"$f":"SUM(J29:J30)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D29*H29","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D30*H30","v":0}]
[]
[]
[null,"Custom & Consultants:",null,null,null,null,null,null,null,{"$f":"SUM(J34:J36)","v":0.3}]
[null,"Soil Test",null,1,null,"acre",null,0.3,null,{"$f":"D34*H34","v":0.3}]
[]
[]
[]
[]
[null,"Machinery Costs:"]
[null,"Fuel ",null,{"$f":"+'T11-15 Machinery Costs'!I48","v":9.2655714285714268},null,"gal",null,{"$f":"+Diesel","v":2.5},null,{"$f":"D40*H40","v":23.163928571428567}]
[null,"Lubricants",null,1,null,"acre",null,{"$f":"+'T11-15 Machinery Costs'!J48","v":4.8920000000000012},null,{"$f":"D41*H41","v":4.8920000000000012}]
[null,"Machinery Repairs ",null,1,null,"acre",null,{"$f":"+'T11-15 Machinery Costs'!G48","v":11.120000000000001},null,{"$f":"D42*H42","v":11.120000000000001}]
[null,"Machinery Labor",null,{"$f":"+'T11-15 Machinery Costs'!M48","v":1.4754},null,"acre",null,{"$f":"+HourlyMachineLabor","v":20},null,{"$f":"D43*H43","v":29.508000000000003}]
[]
[null,"Other:",null,null,null,null,null,null,null,{"$f":"SUM(J47:J52)","v":11}]
[null,"Twine",null,{"$f":"+$D$13","v":1.5},null,"ton",null,{"$f":"twine","v":2},null,{"$f":"D46*H46","v":3}]
[null,"Crop insurance",null,{"$f":"+$D$13","v":1.5},null,"ton",null,{"$f":"+cropinsurance","v":2},null,3]
[null,"Gopher control",null,1,null,"acre",null,{"$f":"+gophercontrol","v":2},null,2]
[null,"Tarping",null,{"$f":"+D13","v":1.5},null,"ton",null,{"$f":"+tarping","v":4},null,6]
[null,"Storage Facility & Equip. Repairs",null,null,null,null,null,null,null,0]
[null,"Other Labor",null,null,null,null,null,null,null,0]
[]
[]
[null,"Overhead1",null,null,null,null,null,null,null,{"$f":"+($J$17+$J$23+$J$28+$J$33+$J$45)*0.05","v":2.7250000000000001}]
[null,"Operating Interest2",null,null,null,null,null,null,null,{"$f":"+($J$17+$J$23+$J$28+$J$33+$J$45)*0.07*0.5","v":1.9075000000000002}]
[]
[null,"Total Operating Costs",null,null,null,null,null,null,null,{"$f":"SUM(J17:J55)-(J17+J23+J28+J33+J45)","v":130.81642857142856}]
[null,"Operating Costs per Unit",null,null,null,null,null,null,null,{"$f":"J57/D13","v":87.210952380952378}]
[]
[null,"Net Returns Above Operating Expenses",null,null,null,null,null,null,null,{"$f":"J13-J57","v":169.18357142857144}]
[]
[null,"Ownership Costs:"]
[null,"Machinery depreciation",null,null,null,null,null,null,null,{"$f":"+'T11-15 Machinery Costs'!C48","v":18.916500000000003}]
[null,"Machinery interest",null,null,null,null,null,null,null,{"$f":"+'T11-15 Machinery Costs'!D48","v":12.529000000000002}]
[null,"Machinery insurance, taxes housing, licenses",null,null,null,null,null,null,null,{"$f":"+'T11-15 Machinery Costs'!E48","v":3.181}]
[null,"Land Cost",null,0.04,null,"percent",null,{"$f":"landvalue1","v":1500},null,{"$f":"+H66*D66","v":60}]
[null,"Land Taxes",null,1,null,"acre",null,{"$f":"landtax","v":5.5},null,{"$f":"D67*H67","v":5.5}]
[]
[null,"Total Ownership Costs",null,null,null,null,null,null,null,{"$f":"SUM(J62:J67)","v":100.12649999999999}]
[null,"Ownership Costs per Unit",null,null,null,null,null,null,null,{"$f":"J69/D13","v":66.750999999999991}]
[]
[null,"Total Costs per Acre",null,null,null,null,null,null,null,{"$f":"J57+J69","v":230.94292857142855}]
[null,"Total Cost per Unit",null,null,null,null,null,null,null,{"$f":"J72/D13","v":153.96195238095237}]
[]
[null,"Returns to Risk",null,null,null,null,null,null,null,{"$f":"J13-J72","v":69.057071428571447}]
[]
[null,"1Covers legal, accounting, and utility fees. Calculated as 5% of operating expenses."]
[null,"2Calculated at 7% interest on operating capital for 6 months."]
[]
[]
[null,"Breakeven Analysis:",null,"-",null,"Base",null,"+"]
[null,null,null,0.1,null,null,null,0.1]
[null,null,null,null,null,"Yield"]
[null,"Price",null,{"$f":"F84*(1-D82)","v":1.35},null,{"$f":"D13","v":1.5},null,{"$f":"F84*1.05","v":1.5750000000000002}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$J$57/D84","v":96.901058201058191},null,{"$f":"$J$57/F84","v":87.210952380952378},null,{"$f":"$J$57/H84","v":83.058049886621305}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$J$69/D84","v":74.167777777777772},null,{"$f":"$J$69/F84","v":66.750999999999991},null,{"$f":"$J$69/H84","v":63.572380952380939}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$J$72/D84","v":171.06883597883595},null,{"$f":"$J$72/F84","v":153.96195238095237},null,{"$f":"$J$72/H84","v":146.63043083900223}]
[]
[]
[null,null,null,null,null,"Price"]
[null,"Yield",null,{"$f":"F94*(1-D82)","v":180},null,{"$f":"H13","v":200},null,{"$f":"F94*(1+H82)","v":220.00000000000003}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$J$57/D94","v":0.72675793650793641},null,{"$f":"$J$57/F94","v":0.65408214285714283},null,{"$f":"$J$57/H94","v":0.59462012987012969}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$J$69/D94","v":0.5562583333333333},null,{"$f":"$J$69/F94","v":0.50063249999999992},null,{"$f":"$J$69/H94","v":0.45512045454545447}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$J$72/D94","v":1.2830162698412697},null,{"$f":"$J$72/F94","v":1.1547146428571429},null,{"$f":"$J$72/H94","v":1.0497405844155843}]

{"sheet":"T5 Alf Est Calendar >15\" ppt","index":6,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[37,1,37,4],[38,1,38,4],[2,1,2,4]]}
[null,"Back to Summary",null,"Input Costs","Alfalfa Establishment >15\" ppt",null,"Machine Costs",null,"Machine Complement"]
[]
[null,"Table 5. Schedule of Operations for Establishing Dryland Organic Alfalfa, >15\" Annual Rainfall"]
[null,"Month","Operation","Tooling"]
[]
[null,"November","Chisel","300HP-WT, 23' Chisel Plow"]
[]
[null,"April","Soil test"]
[]
[null,"April","Apply Manure","Custom spreading"]
[]
[null,"April","Disc","300HP-WT, 35' Tandem Disc"]
[]
[null,"April","Harrow","300HP-WT, 53' Rotary Harrow"]
[]
[null,"April","Pack","300HP-WT, 40' Packer"]
[]
[null,"April","Drill","300HP-WT, 30' Disc Drill"]
[]
[null,"June","Mow Weeds","300HP-WT, 20' Flail Shredder"]
[]
[null,"July","Swath Forage","18' Swather"]
[]
[null,"July","Bale Forage","300HP-WT, 1500-lb Round Baler"]
[]
[null,"July","Pick up & stack bales","300HP-WT, Bale Spear"]
[]
[null,"August","Swath Forage","18' Swather"]
[]
[null,"August","Bale Forage","300HP-WT, 1500-lb Round Baler"]
[]
[null,"August","Pick up & stack bales","300HP-WT, Bale Spear"]
[]
[null,"September","Mow Weeds","300HP-WT, 20' Flail Shredder"]

{"sheet":"T6 Alfalfa Est >15\" ppt","index":7,"n_rows":100,"n_cols":10,"rows_kept":100,"cut":false,"hidden":false,"merged":[[64,1,64,3],[7,1,7,10],[12,12,12,16],[13,12,13,17],[62,1,62,3],[63,1,63,3],[108,1,108,9],[109,1,109,9],[104,1,104,9],[105,1,105,9],[106,1,106,9],[107,1,107,9]]}
[null,"Back to Summary",null,"Input Costs",null,"Calendar",null,"Machine Costs",null,"Machine Complement"]
[null,"Legend: Follow directions below to preserve equations in this spreadsheet."]
[null,"Yellow cells: Data are from Summary page (yellow tab)."]
[null,"Orange cells: Revise data here to reflect your situation."]
[null,"Green cells: Data are from Input Costs page (green tab)."]
[null,"Blue cells: Data are from the Machinery page (blue tab)."]
[null,"Please change yield, price, and length of stand assumptions as necessary to reflect your situation."]
[null,"Table 6. Production Costs for Establishing Dryland Organic Alfalfa, >15\" Annual Rainfall"]
[null,null,null,"Quantity",null,null,null,"Price or",null,"Value or"]
[null,"Item",null,"Per Acre",null,"Unit",null,"Cost/Unit",null,"Cost/Acre"]
[]
[null,"Gross Returns"]
[null,"Alfalfa",null,{"$f":"HighRainfallEstYd","v":2.5},null,"ton",null,{"$f":"+'T1 Summary'!H20","v":200},null,{"$f":"D13*H13","v":500}]
[]
[null,"Operating Inputs"]
[]
[null,"Seed:",null,null,null,null,null,null,null,{"$f":"SUM(J18:J21)","v":39.6}]
[null,"Alfalfa Seed",null,12,null,"lb",null,{"$f":"+AlfalfaSeed","v":3},null,{"$f":"D18*H18","v":36}]
[null,"Alfalfa Seed for re-seeding",null,{"$f":"+D18*0.1","v":1.2000000000000002},null,"lb",null,{"$f":"+AlfalfaSeed","v":3},null,{"$f":"D19*H19","v":3.6000000000000005}]
[null,"   (assume 10% of the time)"]
[]
[]
[null,"Fertilizer:",null,null,null,null,null,null,null,{"$f":"SUM(J24:J26)","v":0}]
[null,"Manure or organic fertilizer",null,null,null,"ton",null,{"$f":"+Manure","v":25},null,{"$f":"D24*H24","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D25*H25","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D26*H26","v":0}]
[]
[null,"Pesticides:",null,null,null,null,null,null,null,{"$f":"SUM(J29:J30)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D29*H29","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D30*H30","v":0}]
[]
[]
[null,"Custom & Consultants:",null,null,null,null,null,null,null,{"$f":"SUM(J34:J36)","v":0.3}]
[null,"Soil Test",null,1,null,"acre",null,0.3,null,{"$f":"D34*H34","v":0.3}]
[]
[]
[]
[null,"Machinery Costs:"]
[null,"Fuel ",null,{"$f":"+'T11-15 Machinery Costs'!I75","v":9.0515714285714282},null,"gal",null,{"$f":"+Diesel","v":2.5},null,{"$f":"D39*H39","v":22.62892857142857}]
[null,"Lubricants",null,1,null,"acre",null,{"$f":"+'T11-15 Machinery Costs'!J75","v":4.7790000000000008},null,{"$f":"D40*H40","v":4.7790000000000008}]
[null,"Machinery Repairs ",null,1,null,"acre",null,{"$f":"+'T11-15 Machinery Costs'!G75","v":10.815000000000001},null,{"$f":"D41*H41","v":10.815000000000001}]
[null,"Machinery Labor",null,{"$f":"+'T11-15 Machinery Costs'!M75","v":1.4494500000000001},null,"acre",null,{"$f":"+HourlyMachineLabor","v":20},null,{"$f":"D42*H42","v":28.989000000000004}]
[]
[null,"Other:",null,null,null,null,null,null,null,{"$f":"SUM(J46:J50)","v":17}]
[null,"Twine",null,{"$f":"+$D$13","v":2.5},null,"ton",null,{"$f":"twine","v":2},null,{"$f":"D45*H45","v":5}]
[null,"Crop insurance",null,{"$f":"+$D$13","v":2.5},null,"ton",null,{"$f":"+cropinsurance","v":2},null,5]
[null,"Gopher control",null,1,null,"acre",null,{"$f":"+gophercontrol","v":2},null,2]
[null,"Tarping",null,{"$f":"+$D$13","v":2.5},null,"acre",null,{"$f":"+tarping","v":4},null,10]
[null,"Storage Facility & Equip. Repairs",null,null,null,null,null,null,null,0]
[null,"Other Labor",null,null,null,null,null,null,null,0]
[]
[]
[]
[null,"Overhead1",null,null,null,null,null,null,null,{"$f":"+($J$17+$J$23+$J$28+$J$33+$J$44)*0.05","v":2.8450000000000002}]
[null,"Operating Interest2",null,null,null,null,null,null,null,{"$f":"+($J$17+$J$23+$J$28+$J$33+$J$44)*0.07*0.5","v":1.9915}]
[]
[null,"Total Operating Costs",null,null,null,null,null,null,null,{"$f":"SUM(J17:J55)-(J17+J23+J28+J33+J44)","v":133.94842857142854}]
[null,"Operating Costs per Unit",null,null,null,null,null,null,null,{"$f":"J57/D13","v":53.579371428571413}]
[]
[null,"Net Returns Above Operating Expenses",null,null,null,null,null,null,null,{"$f":"J13-J57","v":366.05157142857149}]
[]
[null,"Ownership Costs:"]
[null,"Machinery depreciation",null,null,null,null,null,null,null,{"$f":"+'T11-15 Machinery Costs'!C75","v":18.420500000000001}]
[null,"Machinery interest",null,null,null,null,null,null,null,{"$f":"+'T11-15 Machinery Costs'!D75","v":12.208000000000002}]
[null,"Machinery insurance, taxes housing, licenses",null,null,null,null,null,null,null,{"$f":"+'T11-15 Machinery Costs'!E75","v":3.1189999999999998}]
[null,"Land Cost",null,0.04,null,"percent",null,{"$f":"landvalue2","v":2000},null,{"$f":"+H66*D66","v":80}]
[null,"Land Taxes",null,1,null,"acre",null,{"$f":"landtax","v":5.5},null,{"$f":"D67*H67","v":5.5}]
[]
[null,"Total Ownership Costs",null,null,null,null,null,null,null,{"$f":"SUM(J62:J67)","v":119.2475}]
[null,"Ownership Costs per Unit",null,null,null,null,null,null,null,{"$f":"J69/D13","v":47.698999999999998}]
[]
[null,"Total Costs per Acre",null,null,null,null,null,null,null,{"$f":"J57+J69","v":253.19592857142854}]
[null,"Total Cost per Unit",null,null,null,null,null,null,null,{"$f":"J72/D13","v":101.27837142857142}]
[]
[null,"Returns to Risk",null,null,null,null,null,null,null,{"$f":"J13-J72","v":246.80407142857146}]
[null,"1Covers legal, accounting, and utility fees. Calculated as 5% of operating expenses."]
[null,"2Calculated at 7% interest on operating capital for 6 months."]
[]
[]
[]
[null,"Breakeven Analysis:",null,"-",null,"Base",null,"+"]
[null,null,null,0.1,null,null,null,0.1]
[null,null,null,null,null,"Yield"]
[null,"Price",null,{"$f":"F84*(1-D82)","v":2.25},null,{"$f":"D13","v":2.5},null,{"$f":"F84*1.05","v":2.625}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$J$57/D84","v":59.532634920634905},null,{"$f":"$J$57/F84","v":53.579371428571413},null,{"$f":"$J$57/H84","v":51.02797278911563}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$J$69/D84","v":52.998888888888892},null,{"$f":"$J$69/F84","v":47.698999999999998},null,{"$f":"$J$69/H84","v":45.427619047619046}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$J$72/D84","v":112.53152380952379},null,{"$f":"$J$72/F84","v":101.27837142857142},null,{"$f":"$J$72/H84","v":96.455591836734683}]
[]
[]
[null,null,null,null,null,"Price"]
[null,"Yield",null,{"$f":"F94*(1-D82)","v":180},null,{"$f":"H13","v":200},null,{"$f":"F94*(1+H82)","v":220.00000000000003}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$J$57/D94","v":0.74415793650793627},null,{"$f":"$J$57/F94","v":0.66974214285714273},null,{"$f":"$J$57/H94","v":0.60885649350649329}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$J$69/D94","v":0.66248611111111111},null,{"$f":"$J$69/F94","v":0.59623749999999998},null,{"$f":"$J$69/H94","v":0.54203409090909083}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$J$72/D94","v":1.4066440476190474},null,{"$f":"$J$72/F94","v":1.2659796428571426},null,{"$f":"$J$72/H94","v":1.1508905844155841}]

{"sheet":"T7 Calendar for 1 cutting","index":8,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[25,1,25,4],[26,1,26,4],[27,1,27,4]]}
[null,"Back to Summary",null,"Input Costs","Alfalfa Production, 1 cutting",null,"Machine Costs",null,"Machine Complement"]
[]
[]
[null,"Table 7. Schedule of Operations for Producing Organic Dryland Alfalfa, 1 Cutting"]
[null,"Month","Operation","Tooling"]
[null,"March","Harrow 2X","300HP-WT, 53' Rotary Harrow, 2 perpendicular passes"]
[]
[null,"July","Swath Forage","18' Swather"]
[]
[null,"July","Rake Forage","300HP-WT, Side Delivery Rake"]
[]
[null,"July","Bale Forage","300HP-WT, 1500 Round Baler"]
[]
[null,"July","Haul & Stack Bales","300HP-WT, Bale Spear"]
[]
[null,"July","Mow Weeds","300HP-WT, 20' Flail Shredder"]
[]
[null,"September","Mow Weeds","300HP-WT, 20' Flail Shredder"]
[]
[null,"September","Soil test"]
[]
[null,"September","Topdress with manure or organic fertilizer if necessary."]

{"sheet":"T8 Alf Prod, 1 cutting","index":9,"n_rows":100,"n_cols":10,"rows_kept":100,"cut":false,"hidden":false,"merged":[[7,1,7,10],[109,1,109,9],[105,1,105,9],[12,12,12,16],[13,12,13,17],[106,1,106,9],[107,1,107,9],[108,1,108,9],[104,1,104,9],[60,1,60,3],[61,1,61,3],[62,1,62,3]]}
[null,"Back to Summary",null,"Input Costs",null,"Calendar",null,"Machine Costs",null,"Machine Complement"]
[null,"Legend: Follow directions below to preserve equations in this spreadsheet."]
[null,"Yellow cells: Data are from Summary page (yellow tab)."]
[null,"Orange cells: Revise data here to reflect your situation."]
[null,"Green cells: Data are from Input Costs page (green tab)."]
[null,"Blue cells: Data are from the Machinery page (blue tab)."]
[null,"Please change yield, price, and length of stand assumptions as necessary to reflect your situation."]
[null,"Table 8. Production Costs for Dryland Organic Alfalfa Production, <15\" Annual Rainfall (1 cutting)"]
[null,null,null,"Quantity",null,null,null,"Price or",null,"Value or"]
[null,"Item",null,"Per Acre",null,"Unit",null,"Cost/Unit",null,"Cost/Acre"]
[]
[null,"Gross Returns"]
[null,"Alfalfa",null,{"$f":"LowRainfallYd","v":2.5},null,"ton",null,{"$f":"'T1 Summary'!H16","v":200},null,{"$f":"D13*H13","v":500}]
[]
[null,"Operating Inputs"]
[]
[null,"Seed:",null,null,null,null,null,null,null,{"$f":"SUM(J18:J19)","v":0}]
[null,"Alfalfa Seed",null,0,null,"lb",null,{"$f":"+AlfalfaSeed","v":3},null,{"$f":"D18*H18","v":0}]
[]
[]
[null,"Fertilizer:",null,null,null,null,null,null,null,{"$f":"SUM(J22:J24)","v":78.125}]
[null,"Manure or organic fertilizer",null,{"$f":"LowRainfallYd*1.25","v":3.125},null,"ton",null,{"$f":"+Manure","v":25},null,{"$f":"D22*H22","v":78.125}]
[null,null,null,null,null,null,null,null,null,{"$f":"D23*H23","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D24*H24","v":0}]
[]
[null,"Pesticides:",null,null,null,null,null,null,null,{"$f":"SUM(J27:J28)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D27*H27","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D28*H28","v":0}]
[]
[]
[null,"Custom & Consultants:",null,null,null,null,null,null,null,{"$f":"SUM(J32:J34)","v":0.3}]
[null,"Soil Test",null,1,null,"acre",null,0.3,null,{"$f":"D32*H32","v":0.3}]
[]
[]
[]
[null,"Machinery Costs:"]
[null,"Fuel ",null,{"$f":"+'T11-15 Machinery Costs'!I93","v":6.0404285714285724},null,"gal",null,{"$f":"+Diesel","v":2.5},null,{"$f":"D37*H37","v":15.10107142857143}]
[null,"Lubricants",null,1,null,"acre",null,{"$f":"+'T11-15 Machinery Costs'!J93","v":3.1959999999999997},null,{"$f":"D38*H38","v":3.1959999999999997}]
[null,"Machinery Repairs ",null,1,null,"acre",null,{"$f":"+'T11-15 Machinery Costs'!G93","v":6.6199999999999983},null,{"$f":"D39*H39","v":6.6199999999999983}]
[null,"Machinery Labor",null,{"$f":"+'T11-15 Machinery Costs'!M93","v":1.0919999999999999},null,"acre",null,{"$f":"+HourlyMachineLabor","v":20},null,{"$f":"D40*H40","v":21.839999999999996}]
[]
[null,"Other:",null,null,null,null,null,null,null,{"$f":"SUM(J44:J48)","v":17}]
[null,"Twine",null,{"$f":"+$D$13","v":2.5},null,"ton",null,{"$f":"twine","v":2},null,{"$f":"D43*H43","v":5}]
[null,"Crop insurance",null,{"$f":"+$D$13","v":2.5},null,"ton",null,{"$f":"+cropinsurance","v":2},null,5]
[null,"Gopher control",null,1,null,"acre",null,{"$f":"+gophercontrol","v":2},null,2]
[null,"Tarping",null,{"$f":"+$D$13","v":2.5},null,"acre",null,{"$f":"+tarping","v":4},null,10]
[null,"Storage Facility & Equip. Repairs",null,null,null,null,null,null,null,0]
[null,"Other Labor",null,null,null,null,null,null,null,0]
[]
[]
[]
[null,"Overhead1",null,null,null,null,null,null,null,{"$f":"+($J$17+$J$21+$J$26+$J$31+$J$42)*0.05","v":4.7712500000000002}]
[null,"Operating Interest2",null,null,null,null,null,null,null,{"$f":"+($J$17+$J$21+$J$26+$J$31+$J$42)*0.07*0.5","v":3.3398750000000001}]
[]
[null,"Total Operating Costs",null,null,null,null,null,null,null,{"$f":"SUM(J17:J53)-(J17+J21+J26+J31+J42)","v":155.29319642857149}]
[null,"Operating Costs per Unit",null,null,null,null,null,null,null,{"$f":"J55/D13","v":62.117278571428599}]
[]
[null,"Net Returns Above Operating Expenses",null,null,null,null,null,null,null,{"$f":"J13-J55","v":344.70680357142851}]
[]
[null,"Ownership Costs:"]
[null,"Machinery depreciation",null,null,null,null,null,null,null,{"$f":"+'T11-15 Machinery Costs'!C93","v":12.0745}]
[null,"Machinery interest",null,null,null,null,null,null,null,{"$f":"+'T11-15 Machinery Costs'!D93","v":8.0670000000000002}]
[null,"Machinery insurance, taxes housing, licenses",null,null,null,null,null,null,null,{"$f":"+'T11-15 Machinery Costs'!E93","v":2.2569999999999997}]
[null,"Amortized Establishment Cost",null,null,null,null,null,null,null,{"$f":"IF('T4 Alfalfa Est <15\" ppt'!$J$75<0,PMT(0.07,stand1cutting,+'T4 Alfalfa Est <15\" ppt'!$J$75),0)","v":0}]
[null,"Land Cost",null,0.04,null,"percent",null,{"$f":"landvalue1","v":1500},null,{"$f":"+H65*D65","v":60}]
[null,"Land Taxes",null,1,null,"acre",null,{"$f":"landtax","v":5.5},null,{"$f":"D66*H66","v":5.5}]
[]
[null,"Total Ownership Costs",null,null,null,null,null,null,null,{"$f":"SUM(J60:J66)","v":87.898499999999999}]
[null,"Ownership Costs per Unit",null,null,null,null,null,null,null,{"$f":"J68/D13","v":35.159399999999998}]
[]
[null,"Total Costs per Acre",null,null,null,null,null,null,null,{"$f":"J55+J68","v":243.1916964285715}]
[null,"Total Cost per Unit",null,null,null,null,null,null,null,{"$f":"J71/D13","v":97.276678571428604}]
[]
[null,"Returns to Risk",null,null,null,null,null,null,null,{"$f":"J13-J71","v":256.8083035714285}]
[null,"1Covers legal, accounting, and utility fees. Calculated as 5% of operating expenses."]
[null,"2Calculated at 7% interest on operating capital for 6 months."]
[]
[]
[]
[null,"Breakeven Analysis:",null,"-",null,"Base",null,"+"]
[null,null,null,0.1,null,"Yield",null,0.1]
[]
[null,"Price",null,{"$f":"F83*(1-D81)","v":2.25},null,{"$f":"D13","v":2.5},null,{"$f":"F83*1.05","v":2.625}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$J$55/D83","v":69.019198412698444},null,{"$f":"$J$55/F83","v":62.117278571428599},null,{"$f":"$J$55/H83","v":59.159312925170092}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$J$68/D83","v":39.066000000000003},null,{"$f":"$J$68/F83","v":35.159399999999998},null,{"$f":"$J$68/H83","v":33.485142857142854}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$J$71/D83","v":108.08519841269845},null,{"$f":"$J$71/F83","v":97.276678571428604},null,{"$f":"$J$71/H83","v":92.64445578231296}]
[]
[null,null,null,"-",null,"Base",null,"+"]
[null,null,null,0.1,null,"Price",null,0.1]
[]
[null,"Yield",null,{"$f":"F94*(1-D81)","v":180},null,{"$f":"H13","v":200},null,{"$f":"F94*(1+H81)","v":220.00000000000003}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$J$55/D94","v":0.86273998015873055},null,{"$f":"$J$55/F94","v":0.77646598214285745},null,{"$f":"$J$55/H94","v":0.70587816558441574}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$J$68/D94","v":0.48832500000000001},null,{"$f":"$J$68/F94","v":0.43949250000000001},null,{"$f":"$J$68/H94","v":0.39953863636363629}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$J$71/D94","v":1.3510649801587307},null,{"$f":"$J$71/F94","v":1.2159584821428575},null,{"$f":"$J$71/H94","v":1.1054168019480521}]

{"sheet":"T9 Calendar for 2 cuttings","index":10,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,1,2,4],[21,4,22,4],[25,4,26,4],[35,1,35,4],[34,1,34,4]]}
[null,"Back to Summary","Input Costs","Alfalfa Production, 2 cuttings",null,null,"Machine Costs",null,"Machine Complement"]
[]
[null,"Table 9. Schedule of Operations for Producing Dryland Organic Alfalfa, 2 cuttings"]
[null,"Month","Operation","Tooling"]
[null,"March","Harrow 2X","300HP-WT, 53' Rotary Harrow, 2 perpendicular passes"]
[]
[null,"June","Swath Forage","18' Swather"]
[]
[null,"June","Rake Forage","300HP-WT, Side Delivery Rake"]
[]
[null,"June","Bale Forage","300HP-WT, 1500-lb Round Baler"]
[]
[null,"June","Haul & Stack Bales","300HP-WT, Bale Spear"]
[]
[null,"August","Swath Forage","18' Swather"]
[]
[null,"August","Rake Forage","300HP-WT, Side Delivery Rake"]
[]
[null,"August","Bale Forage","300HP-WT, 1500-lb Round Baler"]
[]
[null,"August","Haul & Stack Bales","300HP-WT, Bale Spear"]
[]
[null,"September","Mow Weeds","300HP-WT, 20' Flail Shredder"]
[]
[null,"September","Soil test"]
[]
[null,"September","Top-dress with manure or organic fertilizer if necessary."]

{"sheet":"T10 Alf Prod, 2 cuttings","index":11,"n_rows":95,"n_cols":10,"rows_kept":95,"cut":false,"hidden":false,"merged":[[103,1,103,9],[58,1,58,3],[57,1,57,3],[99,1,99,9],[100,1,100,9],[101,1,101,9],[7,1,7,10],[12,12,12,16],[13,12,13,17],[56,1,56,3],[102,1,102,9]]}
[null,"Back to Summary",null,"Input Costs",null,"Calendar",null,"Machine Costs",null,"Machine Complement"]
[null,"Legend: Follow directions below to preserve equations in this spreadsheet."]
[null,"Yellow cells: Data are from Summary page (yellow tab)."]
[null,"Orange cells: Revise data here to reflect your situation."]
[null,"Green cells: Data are from Input Costs page (green tab)."]
[null,"Blue cells: Data are from the Machinery page (blue tab)."]
[null,"Please change yield, price, and length of stand assumptions as necessary to reflect your situation."]
[null,"Table 10. Production Costs for Dryland Organic Alfalfa Production, > 15\" Annual Rainfall (2 cuttings)"]
[null,null,null,"Quantity",null,null,null,"Price or",null,"Value or"]
[null,"Item",null,"Per Acre",null,"Unit",null,"Cost/Unit",null,"Cost/Acre"]
[]
[null,"Gross Returns"]
[null,"Forage",null,{"$f":"HighRainfallYd","v":3.5},null,"ton",null,{"$f":"+'T1 Summary'!H21","v":200},null,{"$f":"D13*H13","v":700}]
[]
[null,"Operating Inputs"]
[]
[null,"Seed:",null,null,null,null,null,null,null,{"$f":"SUM(J18:J18)","v":0}]
[null,"Alfalfa Seed",null,0,null,"lb",null,{"$f":"+AlfalfaSeed","v":3},null,{"$f":"D18*H18","v":0}]
[]
[null,"Fertilizer:",null,null,null,null,null,null,null,{"$f":"SUM(J22:J23)","v":0}]
[null,"Topdress manure or organic ",null,{"$f":"HighRainfallYd*1.25","v":4.375},null,"acre",null,{"$f":"Manure","v":25},null,{"$f":"D21*H21","v":109.375}]
[null,"fertilizer if necessary",null,null,null,null,null,null,null,{"$f":"D22*H22","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D23*H23","v":0}]
[]
[null,"Pesticides:",null,null,null,null,null,null,null,{"$f":"SUM(J26:J27)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D26*H26","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D27*H27","v":0}]
[]
[null,"Custom & Consultants:",null,null,null,null,null,null,null,{"$f":"SUM(J30:J31)","v":0.3}]
[null,"Soil Test",null,1,null,"acre",null,0.3,null,{"$f":"D30*H30","v":0.3}]
[]
[]
[]
[null,"Machinery Costs:",null,null,null,null,null,null,null,{"$f":"SUM(J35:J38)","v":70.712785714285701}]
[null,"Fuel ",null,{"$f":"+'T11-15 Machinery Costs'!I115","v":9.4947142857142843},null,"gal",null,{"$f":"+Diesel","v":2.5},null,{"$f":"D35*H35","v":23.736785714285709}]
[null,"Lubricants",null,1,null,"acre",null,{"$f":"+'T11-15 Machinery Costs'!J115","v":5.0160000000000009},null,{"$f":"D36*H36","v":5.0160000000000009}]
[null,"Machinery Repairs ",null,1,null,"acre",null,{"$f":"+'T11-15 Machinery Costs'!G115","v":10.280000000000001},null,{"$f":"D37*H37","v":10.280000000000001}]
[null,"Machinery Labor",null,{"$f":"+'T11-15 Machinery Costs'!M115","v":1.5840000000000001},null,"acre",null,{"$f":"+HourlyMachineLabor","v":20},null,{"$f":"D38*H38","v":31.68}]
[]
[null,"Other:",null,null,null,null,null,null,null,{"$f":"SUM(J42:J46)","v":23}]
[null,"Twine",null,{"$f":"+$D$13","v":3.5},null,"ton",null,{"$f":"twine","v":2},null,{"$f":"D41*H41","v":7}]
[null,"Crop insurance",null,{"$f":"+$D$13","v":3.5},null,"ton",null,{"$f":"+cropinsurance","v":2},null,7]
[null,"Gopher control",null,1,null,"acre",null,{"$f":"+gophercontrol","v":2},null,2]
[null,"Tarping",null,{"$f":"+$D$13","v":3.5},null,"acre",null,{"$f":"+tarping","v":4},null,14]
[null,"Storage Facility & Equip. Repairs",null,null,null,null,null,null,null,0]
[null,"Other Labor",null,null,null,null,null,null,null,0]
[]
[null,"Overhead1",null,null,null,null,null,null,null,{"$f":"(+$J$29+$J$25+$J$40+$J$34)*0.05","v":4.7006392857142849}]
[null,"Operating Interest2",null,null,null,null,null,null,null,{"$f":"+(J17+J20+J25+J29+J40)*0.07*0.5","v":0.81550000000000011}]
[]
[null,"Total Operating Costs",null,null,null,null,null,null,null,{"$f":"SUM(J17:J49)-(J17+J20+J25+J29+J40)","v":286.61671071428566}]
[null,"Operating Costs per Unit",null,null,null,null,null,null,null,{"$f":"J51/D13","v":81.890488775510192}]
[]
[null,"Net Returns Above Operating Expenses",null,null,null,null,null,null,null,{"$f":"J13-J51","v":413.38328928571434}]
[]
[null,"Ownership Costs"]
[null,"Machinery depreciation",null,null,null,null,null,null,null,{"$f":"'T11-15 Machinery Costs'!C115","v":18.634499999999999}]
[null,"Machinery interest",null,null,null,null,null,null,null,{"$f":"'T11-15 Machinery Costs'!D115","v":12.277000000000003}]
[null,"Machinery insurance, taxes housing, licence",null,null,null,null,null,null,null,{"$f":"'T11-15 Machinery Costs'!E115","v":3.387}]
[null,"Amortized Establishment Cost ",null,null,null,null,null,null,null,{"$f":"IF('T6 Alfalfa Est >15\" ppt'!$J$75<0,-PMT(0.07,stand2cuttings,+'T6 Alfalfa Est >15\" ppt'!$J$75),0)","v":0}]
[null,"Land Cost",null,0.04,null,"percent",null,{"$f":"landvalue2","v":2000},null,{"$f":"+H61*D61","v":80}]
[null,"Land Taxes",null,1,null,"acre",null,{"$f":"landtax","v":5.5},null,{"$f":"D62*H62","v":5.5}]
[]
[null,"Total Ownership Costs",null,null,null,null,null,null,null,{"$f":"SUM(J56:J61)","v":114.2985}]
[null,"Ownership Costs per Unit",null,null,null,null,null,null,null,{"$f":"J64/D13","v":32.656714285714287}]
[]
[null,"Total Costs per Acre",null,null,null,null,null,null,null,{"$f":"J51+J64","v":400.91521071428565}]
[null,"Total Cost per Unit",null,null,null,null,null,null,null,{"$f":"J67/D13","v":114.54720306122447}]
[]
[null,"Returns to Risk",null,null,null,null,null,null,null,{"$f":"J13-J67","v":299.08478928571435}]
[null,"1Covers legal, accounting, and utility fees. Calculated as 5% of operating expenses."]
[null,"2Calculated at 7% interest on operating capital for 6 months."]
[]
[]
[]
[null,"Breakeven Analysis:",null,"-",null,"Base",null,"+"]
[null,null,null,0.1,null,null,null,0.1]
[null,null,null,null,null,"Yield"]
[null,"Price",null,{"$f":"F79*(1-D77)","v":3.15},null,{"$f":"D13","v":3.5},null,{"$f":"F79*1.05","v":3.6750000000000003}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$J$51/D79","v":90.989431972789106},null,{"$f":"$J$51/F79","v":81.890488775510192},null,{"$f":"$J$51/H79","v":77.990941690962075}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$J$64/D79","v":36.2852380952381},null,{"$f":"$J$64/F79","v":32.656714285714287},null,{"$f":"$J$64/H79","v":31.101632653061223}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$J$67/D79","v":127.27467006802719},null,{"$f":"$J$67/F79","v":114.54720306122447},null,{"$f":"$J$67/H79","v":109.0925743440233}]
[]
[]
[null,null,null,null,null,"Price"]
[null,"Yield",null,{"$f":"F89*(1-D77)","v":180},null,{"$f":"H13","v":200},null,{"$f":"F89*(1+H77)","v":220.00000000000003}]
[]
[null,"Operating Cost Breakeven",null,{"$f":"$J$51/D89","v":1.5923150595238091},null,{"$f":"$J$51/F89","v":1.4330835535714284},null,{"$f":"$J$51/H89","v":1.3028032305194801}]
[]
[null,"Ownership Cost Breakeven",null,{"$f":"$J$64/D89","v":0.63499166666666673},null,{"$f":"$J$64/F89","v":0.57149250000000007},null,{"$f":"$J$64/H89","v":0.51953863636363629}]
[]
[null,"Total Cost Breakeven",null,{"$f":"$J$67/D89","v":2.2273067261904758},null,{"$f":"$J$67/F89","v":2.0045760535714283},null,{"$f":"$J$67/H89","v":1.8223418668831164}]

{"sheet":"T11-15 Machinery Costs","index":12,"n_rows":116,"n_cols":14,"rows_kept":116,"cut":false,"hidden":false,"merged":[[94,1,94,10],[76,1,76,10],[22,1,22,10],[49,1,49,10]]}
[null,"Back to Summary",null,"Back to Contents"]
[null,"Table 11. Per Acre Machinery Costs by Type "]
[null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"Machine/",null,null,null,"Total",null,null,null,null,"Variable",null,null,"Total"]
[null,"Type of Operation","Depreciation","Interest","THI&L1","Fixed Costs","Repairs","Fuel","Fuel","Lube","Costs","Labor","Labor","Costs"]
[null,null,"($/acre)","($/acre)","($/acre)","($/acre)","($/acre)","($/acre)","(gal/acre)","($/acre)","($/acre)","($/acre)","(hr/acre)","($/acre)"]
[]
[null,"23' Chisel, 300HP-CH",1.4,1.03,0.13,2.56,0.82,2.5299999999999998,0.72285714285714275,0.38,{"$f":"+J8+H8+G8","v":3.7299999999999995},1.86,9.2999999999999999E-2,{"$f":"+L8+K8+F8","v":8.15}]
[null,"35' Tandem Disk, 300HP-CH",1.77,1,0.12,{"$f":"SUM(C9:E9)","v":2.89},0.89,1.69,0.48285714285714282,0.25,{"$f":"+J9+H9+G9","v":2.83},1.38,6.8999999999999992E-2,{"$f":"+L9+K9+F9","v":7.1}]
[null,"53' Rotary Harrow, 300HP-CH",0.92,0.65,0.08,1.6500000000000001,0.35,1.24,0.35428571428571426,0.19,1.7799999999999998,1.01,5.0500000000000003E-2,{"$f":"+L10+K10+F10","v":4.4400000000000004}]
[null,"Side Delivery Rake, 300HP-CH",1.1100000000000001,0.81,0.12,2.04,0.56999999999999995,2.3199999999999998,0.66285714285714281,0.35,3.2399999999999998,1.89,9.4500000000000001E-2,7.17]
[null,"40' Packer, 300HP-CH",0.51,0.42,0.06,{"$f":"SUM(C12:E12)","v":0.99},0.23,1.58,0.45142857142857146,0.24,2.0500000000000003,0.97,4.8500000000000001E-2,{"$f":"+L12+K12+F12","v":4.0100000000000007}]
[null,"30' Disk Drill, 300HP-CH",1.76,1.1399999999999999,0.36,3.26,1.58,2.98,0.85142857142857142,0.45,5.01,1.83,9.1499999999999998E-2,10.1]
[null,"20' Flail Shredder, 300HP-CH",1.33,0.88,0.21,2.42,0.72,2.25,0.6428571428571429,0.34,3.3099999999999996,1.6,0.08,7.33]
[null,"18' Swather",2.48,1.27,0.57999999999999996,4.33,1.1499999999999999,1.65,0.47142857142857142,0.25,3.05,2.75,0.13750000000000001,10.129999999999999]
[null,"1500-lb Round Baler, 300HP-CH",1.43,0.89,0.22,{"$f":"SUM(C16:E16)","v":2.54},1.19,2.21,0.63142857142857145,0.33,3.73,1.24,6.2E-2,{"$f":"+L16+K16+F16","v":7.51}]
[null,"Bale Spear, 300HP-WT",1.54,1.24,0.21,2.99,0.75,5.91,1.6885714285714286,0.89,7.55,3.96,0.19800000000000001,14.5]
[null," 0.75-Ton 4WD Pickup",0.73,0.52,0.5,1.74,0.75,1.5,0.42857142857142855,0.23,2.48,4.8,0.24,9.02]
[null,"4WD-ATV",9.2999999999999999E-2,6.0999999999999999E-2,0.01,{"$f":"SUM(C19:E19)","v":0.16400000000000001},0.02,0.14399999999999999,4.1142857142857141E-2,2.1999999999999999E-2,0.18599999999999997,0.88,4.3999999999999997E-2,{"$f":"+L19+K19+F19","v":1.23}]
[null,"50HP-WT with bucket",0.1915,0.216,3.6999999999999998E-2,{"$f":"SUM(C20:E20)","v":0.44449999999999995},0.05,0.42749999999999999,0.12214285714285714,6.4000000000000001E-2,0.54149999999999998,1.1000000000000001,5.5E-2,{"$f":"+L20+K20+F20","v":2.0860000000000003}]
[null,"1Taxes, housing, insurance, and licensing"]
[]
[null,"Table 12. Per Acre Machinery Costs for Establishing Dryland Organic Alfalfa, <15\" Annual Rainfall (1 cutting)"]
[null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,null,null,null,"Total",null,null,null,null,"Variable",null,null,"Total"]
[null,"Type of Machine ","Depreciation","Interest","THI&L1","Fixed Costs","Repairs","Fuel","Fuel","Lube","Costs","Labor","Labor","Costs"]
[null,null,"($/acre)","($/acre)","($/acre)","($/acre)","($/acre)","($/acre)","(gal/acre)","($/acre)","($/acre)","($/acre)","(hr/acre)","($/acre)"]
[null,"23' Chisel, 300HP-CH",1.4,1.03,0.13,2.56,0.82,2.5299999999999998,0.72285714285714275,0.38,3.73,1.86,9.2999999999999999E-2,8.15]
[null,"35' Tandem Disk, 300HP-CH",1.77,1,0.12,{"$f":"SUM(C29:E29)","v":2.89},0.89,1.69,0.48285714285714282,0.25,{"$f":"SUM(G29:J29)","v":3.3128571428571427},1.38,6.8999999999999992E-2,{"$f":"+L29+K29+F29","v":7.5828571428571436}]
[null,{"$f":"HARROW","v":"53' Rotary Harrow, 300HP-CH"},0.92,0.65,0.08,1.6500000000000001,0.35,1.24,0.35428571428571426,{"$f":"HARROW","v":0.19},{"$f":"HARROW","v":1.7799999999999998},{"$f":"HARROW","v":1.01},5.0500000000000003E-2,{"$f":"HARROW","v":4.4400000000000004}]
[null,"30' Disk Drill, 300HP-CH",1.76,1.1399999999999999,0.36,{"$f":"SUM(C31:E31)","v":3.26},1.58,2.98,0.85142857142857142,0.45,{"$f":"SUM(G31:J31)","v":5.8614285714285721},1.83,9.1499999999999998E-2,{"$f":"+L31+K31+F31","v":10.951428571428572}]
[null,"40' Packer, 300HP-CH",0.51,0.42,0.06,{"$f":"SUM(C32:E32)","v":0.99},0.23,1.58,0.45142857142857146,0.24,{"$f":"SUM(G32:J32)","v":2.5014285714285718},0.97,4.8500000000000001E-2,{"$f":"+L32+K32+F32","v":4.4614285714285717}]
[null,"For re-seeding (20% of the time):"]
[null,"35' Tandem Disk, 300HP-CH",{"$f":"0.2*C29","v":0.35400000000000004},{"$f":"0.2*D29","v":0.2},2.4E-2,0.57800000000000007,0.17800000000000002,0.33800000000000002,9.6571428571428572E-2,0.05,0.66257142857142859,0.27599999999999997,1.38E-2,1.5165714285714289]
[null,{"$f":"HARROW","v":"53' Rotary Harrow, 300HP-CH"},{"$f":"0.2*C30","v":0.18400000000000002},0.13,1.6E-2,0.33000000000000007,6.9999999999999993E-2,0.248,7.0857142857142855E-2,3.8000000000000006E-2,0.35599999999999998,0.20200000000000001,1.0100000000000001E-2,0.88800000000000012]
[null,"30' Disk Drill, 300HP-CH",0.35200000000000004,0.22799999999999998,7.1999999999999995E-2,0.65200000000000002,0.31600000000000006,0.59599999999999997,0.17028571428571429,9.0000000000000011E-2,1.1722857142857144,0.36600000000000005,1.83E-2,2.1902857142857144]
[null,"40' Packer, 300HP-CH",0.10200000000000001,8.4000000000000005E-2,1.2E-2,0.19800000000000001,4.6000000000000006E-2,0.31600000000000006,9.0285714285714302E-2,4.8000000000000001E-2,0.50028571428571433,0.19400000000000001,9.7000000000000003E-3,0.89228571428571435]
[null,"20' Flail Shredder, 300HP-CH",{"$f":"SHREDDER","v":1.33},0.88,0.21,2.42,0.72,2.25,0.6428571428571429,{"$f":"SHREDDER","v":0.34},{"$f":"SHREDDER","v":3.3099999999999996},{"$f":"SHREDDER","v":1.6},0.08,{"$f":"SHREDDER","v":7.33}]
[null,{"$f":"SWATHER","v":"18' Swather"},2.48,1.27,0.57999999999999996,4.33,1.1499999999999999,1.65,0.47142857142857142,{"$f":"SWATHER","v":0.25},{"$f":"SWATHER","v":3.05},{"$f":"SWATHER","v":2.75},0.13750000000000001,{"$f":"SWATHER","v":10.129999999999999}]
[null,"Side Delivery Rake, 300HP-CH",{"$f":"RAKE","v":1.1100000000000001},0.81,0.12,2.04,0.56999999999999995,2.3199999999999998,0.66285714285714281,{"$f":"RAKE","v":0.35},{"$f":"RAKE","v":3.2399999999999998},{"$f":"RAKE","v":1.89},9.4500000000000001E-2,{"$f":"RAKE","v":7.17}]
[null,"1500-lb Round Baler, 300HP-CH",{"$f":"baler","v":1.43},0.89,0.22,2.54,1.19,2.21,0.63142857142857145,{"$f":"baler","v":0.33},{"$f":"baler","v":3.73},{"$f":"baler","v":1.24},6.2E-2,{"$f":"baler","v":7.51}]
[null,"Bale Spear, 300HP-WT",{"$f":"SPEAR","v":1.54},1.24,0.21,2.99,0.75,5.91,1.6885714285714286,{"$f":"SPEAR","v":0.89},{"$f":"SPEAR","v":7.55},{"$f":"SPEAR","v":3.96},0.19800000000000001,{"$f":"SPEAR","v":14.5}]
[null,"20' Flail Shredder, 300HP-CH",{"$f":"SHREDDER","v":1.33},0.88,0.21,2.42,0.72,2.25,0.6428571428571429,{"$f":"SHREDDER","v":0.34},3.3099999999999996,1.6,0.08,{"$f":"SHREDDER","v":7.33}]
[null,"20' Flail Shredder, 300HP-CH",1.33,0.88,0.21,2.42,0.72,2.25,0.6428571428571429,0.34,3.3099999999999996,1.6,0.08,{"$f":"SHREDDER","v":7.33}]
[null,{"$f":"PU","v":" 0.75-Ton 4WD Pickup"},0.73,0.52,0.5,1.74,0.75,1.5,0.42857142857142855,{"$f":"PU","v":0.23},{"$f":"PU","v":2.48},{"$f":"PU","v":4.8},0.24,{"$f":"PU","v":9.02}]
[null,{"$f":"ATV","v":"4WD-ATV"},9.2999999999999999E-2,6.0999999999999999E-2,0.01,0.16400000000000001,0.02,0.14399999999999999,4.1142857142857141E-2,{"$f":"ATV","v":2.1999999999999999E-2},{"$f":"ATV","v":0.18599999999999997},{"$f":"ATV","v":0.88},4.3999999999999997E-2,{"$f":"ATV","v":1.23}]
[null,{"$f":"BUCKET","v":"50HP-WT with bucket"},0.1915,0.216,3.6999999999999998E-2,0.44449999999999995,0.05,0.42749999999999999,0.12214285714285714,{"$f":"BUCKET","v":6.4000000000000001E-2},{"$f":"BUCKET","v":0.54149999999999998},{"$f":"BUCKET","v":1.1000000000000001},5.5E-2,{"$f":"BUCKET","v":2.0860000000000003}]
[null,"Total",{"$f":"SUM(C28:C47)","v":18.916500000000003},12.529000000000002,3.181,34.616500000000002,11.120000000000001,32.429500000000004,9.2655714285714268,4.8920000000000012,50.584357142857137,29.508000000000003,1.4754,114.70885714285714]
[null,"1Taxes, housing, insurance, and licensing"]
[null,"Table 13. Per Acre Machinery Costs for Establishing Dryland Organic Alfalfa, >15\" Annual Rainfall (1 cutting)"]
[null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,null,null,null,"Total",null,null,null,null,"Variable",null,null,"Total"]
[null,"Type of Machine ","Depreciation","Interest","THI&L1","Fixed Costs","Repairs","Fuel","Fuel","Lube","Costs","Labor","Labor","Costs"]
[null,null,"($/acre)","($/acre)","($/acre)","($/acre)","($/acre)","($/acre)","(gal/acre)","($/acre)","($/acre)","($/acre)","(hr/acre)","($/acre)"]
[null,"23' Chisel, 300HP-CH",1.4,1.03,0.13,2.56,0.82,2.5299999999999998,0.72285714285714275,0.38,3.73,1.86,9.2999999999999999E-2,8.15]
[null,"35' Tandem Disk, 300HP-CH",1.77,1,0.12,{"$f":"SUM(C56:E56)","v":2.89},0.89,1.69,0.48285714285714282,0.25,{"$f":"SUM(G56:J56)","v":3.3128571428571427},1.38,6.8999999999999992E-2,{"$f":"+L56+K56+F56","v":7.5828571428571436}]
[null,{"$f":"HARROW","v":"53' Rotary Harrow, 300HP-CH"},0.92,0.65,0.08,1.6500000000000001,0.35,1.24,0.35428571428571426,{"$f":"HARROW","v":0.19},{"$f":"HARROW","v":1.7799999999999998},{"$f":"HARROW","v":1.01},5.0500000000000003E-2,{"$f":"HARROW","v":4.4400000000000004}]
[null,"30' Disk Drill, 300HP-CH",1.76,1.1399999999999999,0.36,{"$f":"SUM(C58:E58)","v":3.26},1.58,2.98,0.85142857142857142,0.45,{"$f":"SUM(G58:J58)","v":5.8614285714285721},1.83,9.1499999999999998E-2,{"$f":"+L58+K58+F58","v":10.951428571428572}]
[null,"40' Packer, 300HP-CH",0.51,0.42,0.06,{"$f":"SUM(C59:E59)","v":0.99},0.23,1.58,0.45142857142857146,0.24,{"$f":"SUM(G59:J59)","v":2.5014285714285718},0.97,4.8500000000000001E-2,{"$f":"+L59+K59+F59","v":4.4614285714285717}]
[null,"For re-seeding (10% of the time):"]
[null,"35' Tandem Disk, 300HP-CH",{"$f":"0.1*C56","v":0.17700000000000002},{"$f":"0.1*D56","v":0.1},1.2E-2,0.28900000000000003,8.900000000000001E-2,0.16900000000000001,4.8285714285714286E-2,2.5000000000000001E-2,0.33128571428571429,0.13799999999999998,6.8999999999999999E-3,0.75828571428571445]
[null,{"$f":"HARROW","v":"53' Rotary Harrow, 300HP-CH"},{"$f":"0.1*C57","v":9.2000000000000012E-2},6.5000000000000002E-2,8.0000000000000002E-3,0.16500000000000004,3.4999999999999996E-2,0.124,3.5428571428571427E-2,1.9000000000000003E-2,0.17799999999999999,0.10100000000000001,5.0500000000000007E-3,0.44400000000000006]
[null,"30' Disk Drill, 300HP-CH",0.17600000000000002,0.11399999999999999,3.5999999999999997E-2,0.32600000000000001,0.15800000000000003,0.29799999999999999,8.5142857142857145E-2,4.5000000000000005E-2,0.58614285714285719,0.18300000000000002,9.1500000000000001E-3,1.0951428571428572]
[null,"40' Packer, 300HP-CH",5.1000000000000004E-2,4.2000000000000003E-2,6.0000000000000001E-3,9.9000000000000005E-2,2.3000000000000003E-2,0.15800000000000003,4.5142857142857151E-2,2.4E-2,0.25014285714285717,9.7000000000000003E-2,4.8500000000000001E-3,0.44614285714285717]
[null,"20' Flail Shredder, 300HP-CH",{"$f":"SHREDDER","v":1.33},0.88,0.21,2.42,0.72,2.25,0.6428571428571429,{"$f":"SHREDDER","v":0.34},{"$f":"SHREDDER","v":3.3099999999999996},{"$f":"SHREDDER","v":1.6},0.08,{"$f":"SHREDDER","v":7.33}]
[null,{"$f":"SWATHER","v":"18' Swather"},2.48,1.27,0.57999999999999996,4.33,1.1499999999999999,1.65,0.47142857142857142,{"$f":"SWATHER","v":0.25},{"$f":"SWATHER","v":3.05},{"$f":"SWATHER","v":2.75},0.13750000000000001,{"$f":"SWATHER","v":10.129999999999999}]
[null,"Side Delivery Rake, 300HP-CH",{"$f":"RAKE","v":1.1100000000000001},0.81,0.12,2.04,0.56999999999999995,2.3199999999999998,0.66285714285714281,{"$f":"RAKE","v":0.35},{"$f":"RAKE","v":3.2399999999999998},{"$f":"RAKE","v":1.89},9.4500000000000001E-2,{"$f":"RAKE","v":7.17}]
[null,"1500-lb Round Baler, 300HP-CH",{"$f":"baler","v":1.43},0.89,0.22,2.54,1.19,2.21,0.63142857142857145,{"$f":"baler","v":0.33},{"$f":"baler","v":3.73},{"$f":"baler","v":1.24},6.2E-2,{"$f":"baler","v":7.51}]
[null,"Bale Spear, 300HP-WT",{"$f":"SPEAR","v":1.54},1.24,0.21,2.99,0.75,5.91,1.6885714285714286,{"$f":"SPEAR","v":0.89},{"$f":"SPEAR","v":7.55},{"$f":"SPEAR","v":3.96},0.19800000000000001,{"$f":"SPEAR","v":14.5}]
[null,"20' Flail Shredder, 300HP-CH",{"$f":"SHREDDER","v":1.33},0.88,0.21,2.42,0.72,2.25,0.6428571428571429,{"$f":"SHREDDER","v":0.34},3.3099999999999996,1.6,0.08,{"$f":"SHREDDER","v":7.33}]
[null,"20' Flail Shredder, 300HP-CH",1.33,0.88,0.21,2.42,0.72,2.25,0.6428571428571429,0.34,3.3099999999999996,1.6,0.08,{"$f":"SHREDDER","v":7.33}]
[null,{"$f":"PU","v":" 0.75-Ton 4WD Pickup"},0.73,0.52,0.5,1.74,0.75,1.5,0.42857142857142855,{"$f":"PU","v":0.23},{"$f":"PU","v":2.48},{"$f":"PU","v":4.8},0.24,{"$f":"PU","v":9.02}]
[null,{"$f":"ATV","v":"4WD-ATV"},9.2999999999999999E-2,6.0999999999999999E-2,0.01,0.16400000000000001,0.02,0.14399999999999999,4.1142857142857141E-2,{"$f":"ATV","v":2.1999999999999999E-2},{"$f":"ATV","v":0.18599999999999997},{"$f":"ATV","v":0.88},4.3999999999999997E-2,{"$f":"ATV","v":1.23}]
[null,{"$f":"BUCKET","v":"50HP-WT with bucket"},0.1915,0.216,3.6999999999999998E-2,0.44449999999999995,0.05,0.42749999999999999,0.12214285714285714,{"$f":"BUCKET","v":6.4000000000000001E-2},{"$f":"BUCKET","v":0.54149999999999998},{"$f":"BUCKET","v":1.1000000000000001},5.5E-2,{"$f":"BUCKET","v":2.0860000000000003}]
[null,"Total",{"$f":"SUM(C55:C74)","v":18.420500000000001},12.208000000000002,3.1189999999999998,33.737500000000004,10.815000000000001,31.680499999999999,9.0515714285714282,{"$f":"SUM(J55:J74)","v":4.7790000000000008},49.238785714285711,28.989000000000004,1.4494500000000001,{"$f":"SUM(N55:N74)","v":111.96528571428571}]
[null,"1Taxes, housing, insurance, and licensing"]
[null,"Table 14. Per Acre Machinery Costs for Producing Dryland Organic Alfalfa, <15\" Annual Rainfall (1 cutting)"]
[null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,null,null,null,"Total",null,null,null,null,"Variable",null,null,"Total"]
[null,"Type of Machine ","Depreciation","Interest","THI&L1","Fixed Costs","Repairs","Fuel","Fuel","Lube","Costs","Labor","Labor","Costs"]
[null,null,"($/acre)","($/acre)","($/acre)","($/acre)","($/acre)","($/acre)","(gal/acre)","($/acre)","($/acre)","($/acre)","(hr/acre)","($/acre)"]
[null,{"$f":"HARROW","v":"53' Rotary Harrow, 300HP-CH"},0.92,0.65,0.08,1.6500000000000001,0.35,1.24,0.35428571428571426,{"$f":"HARROW","v":0.19},1.7799999999999998,1.01,5.0500000000000003E-2,{"$f":"HARROW","v":4.4400000000000004}]
[null,"53' Rotary Harrow, 300HP-CH",0.92,0.65,0.08,1.6500000000000001,0.35,1.24,0.35428571428571426,0.19,1.7799999999999998,1.01,5.0500000000000003E-2,{"$f":"HARROW","v":4.4400000000000004}]
[null,{"$f":"SWATHER","v":"18' Swather"},2.48,1.27,0.57999999999999996,4.33,1.1499999999999999,1.65,0.47142857142857142,{"$f":"SWATHER","v":0.25},{"$f":"SWATHER","v":3.05},{"$f":"SWATHER","v":2.75},0.13750000000000001,{"$f":"SWATHER","v":10.129999999999999}]
[null,"Side Delivery Rake, 300HP-CH",{"$f":"RAKE","v":1.1100000000000001},0.81,0.12,2.04,0.56999999999999995,2.3199999999999998,0.66285714285714281,{"$f":"RAKE","v":0.35},{"$f":"RAKE","v":3.2399999999999998},{"$f":"RAKE","v":1.89},9.4500000000000001E-2,{"$f":"RAKE","v":7.17}]
[null,"1500-lb Round Baler, 300HP-CH",{"$f":"baler","v":1.43},0.89,0.22,2.54,1.19,2.21,0.63142857142857145,{"$f":"baler","v":0.33},{"$f":"baler","v":3.73},{"$f":"baler","v":1.24},6.2E-2,{"$f":"baler","v":7.51}]
[null,"Bale Spear, 300HP-WT",{"$f":"SPEAR","v":1.54},1.24,0.21,2.99,0.75,5.91,1.6885714285714286,{"$f":"SPEAR","v":0.89},{"$f":"SPEAR","v":7.55},{"$f":"SPEAR","v":3.96},0.19800000000000001,{"$f":"SPEAR","v":14.5}]
[null,"20' Flail Shredder, 300HP-CH",{"$f":"SHREDDER","v":1.33},0.88,0.21,2.42,0.72,2.25,0.6428571428571429,{"$f":"SHREDDER","v":0.34},3.3099999999999996,1.6,0.08,{"$f":"SHREDDER","v":7.33}]
[null,"20' Flail Shredder, 300HP-CH",1.33,0.88,0.21,2.42,0.72,2.25,0.6428571428571429,0.34,3.3099999999999996,1.6,0.08,{"$f":"SHREDDER","v":7.33}]
[null,{"$f":"PU","v":" 0.75-Ton 4WD Pickup"},0.73,0.52,0.5,1.74,0.75,1.5,0.42857142857142855,{"$f":"PU","v":0.23},{"$f":"PU","v":2.48},{"$f":"PU","v":4.8},0.24,{"$f":"PU","v":9.02}]
[null,{"$f":"ATV","v":"4WD-ATV"},9.2999999999999999E-2,6.0999999999999999E-2,0.01,0.16400000000000001,0.02,0.14399999999999999,4.1142857142857141E-2,{"$f":"ATV","v":2.1999999999999999E-2},{"$f":"ATV","v":0.18599999999999997},{"$f":"ATV","v":0.88},4.3999999999999997E-2,{"$f":"ATV","v":1.23}]
[null,{"$f":"BUCKET","v":"50HP-WT with bucket"},0.1915,0.216,3.6999999999999998E-2,0.44449999999999995,0.05,0.42749999999999999,0.12214285714285714,{"$f":"BUCKET","v":6.4000000000000001E-2},{"$f":"BUCKET","v":0.54149999999999998},{"$f":"BUCKET","v":1.1000000000000001},5.5E-2,{"$f":"BUCKET","v":2.0860000000000003}]
[null,"Total",{"$f":"SUM(C82:C92)","v":12.0745},8.0670000000000002,2.2569999999999997,22.388500000000001,6.6199999999999983,21.141499999999997,6.0404285714285724,3.1959999999999997,{"$f":"SUM(K82:K92)","v":30.957499999999996},21.84,1.0919999999999999,{"$f":"SUM(N82:N92)","v":75.185999999999993}]
[null,"1Taxes, housing, insurance, and licensing"]
[null,"Table 15. Per Acre Machinery Costs for Producing Dryland Organic Alfalfa, >15\" Annual Rainfall (2 cuttings)"]
[null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,null,null,null,"Total",null,null,null,null,"Variable",null,null,"Total"]
[null,"Type of Machine ","Depreciation","Interest","THI&L1","Fixed Costs","Repairs","Fuel","Fuel","Lube","Costs","Labor","Labor","Costs"]
[null,null,"($/acre)","($/acre)","($/acre)","($/acre)","($/acre)","($/acre)","(gal/acre)","($/acre)","($/acre)","($/acre)","(hr/acre)","($/acre)"]
[null,{"$f":"HARROW","v":"53' Rotary Harrow, 300HP-CH"},0.92,0.65,0.08,1.6500000000000001,0.35,1.24,0.35428571428571426,{"$f":"HARROW","v":0.19},1.7799999999999998,1.01,5.0500000000000003E-2,{"$f":"HARROW","v":4.4400000000000004}]
[null,"53' Rotary Harrow, 300HP-CH",0.92,0.65,0.08,1.6500000000000001,0.35,1.24,0.35428571428571426,0.19,1.7799999999999998,1.01,5.0500000000000003E-2,{"$f":"HARROW","v":4.4400000000000004}]
[null,{"$f":"SWATHER","v":"18' Swather"},2.48,1.27,0.57999999999999996,4.33,1.1499999999999999,1.65,0.47142857142857142,{"$f":"SWATHER","v":0.25},{"$f":"SWATHER","v":3.05},{"$f":"SWATHER","v":2.75},0.13750000000000001,{"$f":"SWATHER","v":10.129999999999999}]
[null,{"$f":"RAKE","v":"Side Delivery Rake, 300HP-CH"},1.1100000000000001,0.81,0.12,2.04,0.56999999999999995,2.3199999999999998,0.66285714285714281,{"$f":"RAKE","v":0.35},{"$f":"RAKE","v":3.2399999999999998},{"$f":"RAKE","v":1.89},9.4500000000000001E-2,{"$f":"RAKE","v":7.17}]
[null,"1500-lb Round Baler, 300HP-CH",{"$f":"baler","v":1.43},0.89,0.22,2.54,1.19,2.21,0.63142857142857145,{"$f":"baler","v":0.33},{"$f":"baler","v":3.73},{"$f":"baler","v":1.24},6.2E-2,{"$f":"baler","v":7.51}]
[null,{"$f":"SWATHER","v":"18' Swather"},2.48,1.27,0.57999999999999996,4.33,1.1499999999999999,1.65,0.47142857142857142,{"$f":"SWATHER","v":0.25},{"$f":"SWATHER","v":3.05},{"$f":"SWATHER","v":2.75},0.13750000000000001,{"$f":"SWATHER","v":10.129999999999999}]
[null,"Bale spear, 300HP-WT",{"$f":"SPEAR","v":1.54},1.24,0.21,2.99,0.75,5.91,1.6885714285714286,{"$f":"SPEAR","v":0.89},{"$f":"SPEAR","v":7.55},{"$f":"SPEAR","v":3.96},0.19800000000000001,{"$f":"SPEAR","v":14.5}]
[null,"Side Delivery Rake, 300HP-CH",{"$f":"RAKE","v":1.1100000000000001},0.81,0.12,2.04,0.56999999999999995,2.3199999999999998,0.66285714285714281,{"$f":"RAKE","v":0.35},{"$f":"RAKE","v":3.2399999999999998},{"$f":"RAKE","v":1.89},9.4500000000000001E-2,{"$f":"RAKE","v":7.17}]
[null,"1500-lb Round Baler, 300HP-CH",{"$f":"baler","v":1.43},0.89,0.22,2.54,1.19,2.21,0.63142857142857145,{"$f":"baler","v":0.33},{"$f":"baler","v":3.73},{"$f":"baler","v":1.24},6.2E-2,{"$f":"baler","v":7.51}]
[null,"Bale Spear, 300HP-WT",{"$f":"SPEAR","v":1.54},1.24,0.21,2.99,0.75,5.91,1.6885714285714286,{"$f":"SPEAR","v":0.89},{"$f":"SPEAR","v":7.55},{"$f":"SPEAR","v":3.96},0.19800000000000001,{"$f":"SPEAR","v":14.5}]
[null,"20' Flail Shredder, 300HP-CH",{"$f":"SHREDDER","v":1.33},0.88,0.21,2.42,0.72,2.25,0.6428571428571429,{"$f":"SHREDDER","v":0.34},3.3099999999999996,1.6,0.08,{"$f":"SHREDDER","v":7.33}]
[null,"20' Flail Shredder, 300HP-CH",1.33,0.88,0.21,2.42,0.72,2.25,0.6428571428571429,0.34,3.3099999999999996,1.6,0.08,{"$f":"SHREDDER","v":7.33}]
[null,{"$f":"PU","v":" 0.75-Ton 4WD Pickup"},0.73,0.52,0.5,1.74,0.75,1.5,0.42857142857142855,{"$f":"PU","v":0.23},{"$f":"PU","v":2.48},{"$f":"PU","v":4.8},0.24,{"$f":"PU","v":9.02}]
[null,{"$f":"ATV","v":"4WD-ATV"},9.2999999999999999E-2,6.0999999999999999E-2,0.01,0.16400000000000001,0.02,0.14399999999999999,4.1142857142857141E-2,{"$f":"ATV","v":2.1999999999999999E-2},{"$f":"ATV","v":0.18599999999999997},{"$f":"ATV","v":0.88},4.3999999999999997E-2,{"$f":"ATV","v":1.23}]
[null,{"$f":"BUCKET","v":"50HP-WT with bucket"},0.1915,0.216,3.6999999999999998E-2,0.44449999999999995,0.05,0.42749999999999999,0.12214285714285714,{"$f":"BUCKET","v":6.4000000000000001E-2},{"$f":"BUCKET","v":0.54149999999999998},{"$f":"BUCKET","v":1.1000000000000001},5.5E-2,{"$f":"BUCKET","v":2.0860000000000003}]
[null,"Total",{"$f":"SUM(C100:C114)","v":18.634499999999999},12.277000000000003,3.387,34.288500000000006,10.280000000000001,33.231499999999997,9.4947142857142843,5.0160000000000009,48.527499999999996,31.680000000000003,1.5840000000000001,{"$f":"SUM(N100:N114)","v":114.496}]
[null,"1Taxes, housing, insurance, and licensing"]

{"sheet":"T16 Machinery Complement","index":13,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[46,1,46,9]]}
[null,"Back to Summary",null,"Back to Contents"]
[]
[null,"Table 16. Machinery Complement for Dryland Organic Alfalfa Production"]
[]
[null,null,null,null,null,null,null,"Annual"]
[null,null,null,null,null,"Annual ",null,"Repairs","Gallons"]
[null,"Type of","Current","Age When","Years of","Hours","Salvage","(Materials","of","Labor","Acres"]
[null,"Machine","Value","Purchased","Life","of Use","Value","& Labor)","Fuel/Hr.","Multiplier","per Hour"]
[null,null,"$",null,null,null,"$","$"]
[null,"50HP-WT with bucket",15000,10,20,150,3500,150,2.85,1.1000000000000001]
[null,"300HP-Challenger",95000,5,15,600,20000,2500,10,1.1000000000000001]
[null,"23' Chisel",17500,0,15,125,2000,700,10,1.1000000000000001,11.85]
[null,"35' Tandem Disk",19000,8,12,75,1000,750,9,1.1000000000000001,16]
[null,"53' Rotary Harrow",19500,0,15,100,2000,350,10,1.1000000000000001,20]
[null,"50' Rotary Hoe",18000,0,10,100,7000,400,10,1.1000000000000001,56]
[null,"Side Delivery Rake",12000,0,10,200,3000,500,10,1.1000000000000001,12]
[null,"40' Packer",9500,0,20,100,1000,150,9,1.1000000000000001,25]
[null,"30' Disk Drill",35000,0,12,170,5000,2800,12,1.2,13]
[null,"20' Flail Shredder",14000,0,10,150,2500,670,10,1.1000000000000001,12]
[null,"18' Swather",66500,0,10,250,12500,2500,4.8,1.1000000000000001,8.73]
[null,"1500-lb Round Baler",20000,0,10,150,3300,1784,10,1.2,5]
[null,"Bale Spear",600,0,20,150,0,0,0,1.2,5.55]
[null,"3/4-Ton Pickup",22000,0,10,400,7500,1500,12,1.2]
[null,"4WD-ATV",5000,0,10,150,1500,75,1.2,1.1000000000000001]